package com.yidu.qianfeng.mapper;

import com.yidu.qianfeng.common.bean.check.Check;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository("checkMapper")
@Mapper
public interface CheckMapper {
    public int insertcheck(Check check);
    /**
     * 查询扫码的所有数据
     * @return
     */
    public List<Check> getAllCheck(int count, int limit);
    /**
     * 根据单号返回总共有多少条数据
     * @param mid
     * @return
     */
    public int getcountCheck(String mid);
    /**
     * 根据单号修改核对数
     * @param check
     * @return
     */
    public int updatecheckcount(Check check);
    /**
     * 查询所有数据行
     * @return
     */
    public int getallcheck();

    /**
     * 根据check_id删除数据
     * @param check_id
     * @return
     */
    public int deletecheck(String check_id);

    /**
     * 根据num查询该id的所有数据
     * @param check_waybill_consign_num
     * @param count
     * @param limit
     * @return
     */
    public List<Check> getoneCheck(String check_waybill_consign_num ,int count, int limit);

    /**
     * 根据num修改size
     * @param check_load_count
     * @param check_waybill_consign_num
     * @return
     */
    public int updatecheckcount1(String check_waybill_consign_num ,int check_load_count);

    /**
     * 根据
     * @return
     */
    public List<Check> selectallone();

    /**
     * 根据check_id修改核对状态
     * @param check_id
     * @param check_car_loading
     * @return
     */
    public int updateload(String check_id,String check_car_loading);

    /**
     * 根据模糊查询信息
     * @param check_waybill_consign_num
     * @param check_car_loading
     * @param shipper_com
     * @param check_date
     * @param waybill_reach_city
     * @return
     */
    public List<Check> selectallyuju(String check_waybill_consign_num,String check_car_loading,String shipper_com,String check_date,String waybill_reach_city);

    /**
     * 卸货扫码查询所有信息
     * @return
     */
    public List<Check> getunloadCheck(int count, int limit);

    /**
     * 根据托运单号查询多少条数据
     * @param check_waybill_consign_num
     * @return
     */
    public int countunload(String check_waybill_consign_num);

    /**
     * 根据托运单号修改核对数
     * @param
     * @return
     */
    public int updatecheckcount2(Check check);

    /**
     * 根据托运单号查询卸货数据
     * @param check_waybill_consign_num
     * @param count
     * @param limit
     * @return
     */
    public List<Check> getoneCheck1(String check_waybill_consign_num ,int count, int limit);

    /**
     * 修改卸货的核对数
     * @param check_unload_count
     * @param check_waybill_consign_num
     * @return
     */
    public int updatecheckcount3(int check_unload_count,String check_waybill_consign_num);

    /**
     * 查询卸货有多少条数据
     * @return
     */
    public int getallcheck1();

    /**
     * 查询卸货序列的所有数据
     * @return
     */
    public List<Check> selectallone1();

    /**
     * 卸货序列动态语句查询数据
     * @param check_waybill_consign_num
     * @param check_car_loading
     * @param shipper_com
     * @param check_date
     * @param waybill_reach_city
     * @return
     */
    public List<Check> selectallyuju1(String check_waybill_consign_num,String check_car_loading,String shipper_com,String check_date,String waybill_reach_city);

    /**
     * 查询派送序列有多少条数据
     * @param check_waybill_consign_num
     * @return
     */
    public int countdelivery(String check_waybill_consign_num);

    /**
     * 修改派送核对数
     * @param check
     * @return
     */
    public int updatedeliverycount(Check check);

    /**
     * 查询派送序列的所有数据
     * @return
     */
    public List<Check> getAlldelivery(int count, int limit);

    /**
     * 查询派送有多少条数据
     * @return
     */
    public int getalldelivery();

    /**
     * 根据托运单号查询数据
     * @param check_waybill_consign_num
     * @param count
     * @param limit
     * @return
     */
    public List<Check> getonedelivery(String check_waybill_consign_num ,int count, int limit);

    /**
     * 根据派送核对数修改派送核对数
     * @param check_delivery_count
     * @param check_waybill_consign_num
     * @return
     */
    public int updatedelivery(int check_delivery_count,String check_waybill_consign_num);

    /**
     * 查询派送序列中的所有数据
     * @return
     */
    public List<Check> selectdelivery();

    /**
     * 派送序列的动态查询语句
     * @param check_waybill_consign_num
     * @param check_car_loading
     * @param shipper_com
     * @param check_date
     * @param waybill_reach_city
     * @return
     */
    public List<Check> selectallyuju2(String check_waybill_consign_num,String check_car_loading,String shipper_com,String check_date,String waybill_reach_city);

    /**
     * 根据托运单号查询有多少条数据
     * @param check_waybill_consign_num
     * @return
     */
    public int countsigner(String check_waybill_consign_num);

    /**
     * 根据托运单号修改核对数
     * @param check
     * @return
     */
    public int updatesignercount(Check check);

    /**
     * 查询签收中的所有数据
     * @param count
     * @param limit
     * @return
     */
    public List<Check> getAllsigner(int count, int limit);

    /**
     * 查询签收中有多少条数据
     * @return
     */
    public int getallsigner();

    /**
     * 根据托运单号查询签收数据
     * @param check_waybill_consign_num
     * @param count
     * @param limit
     * @return
     */
    public List<Check> getonesigner(String check_waybill_consign_num ,int count, int limit);

    /**
     * 根据托运单号修改核对数
     * @param check_sign_count
     * @param check_waybill_consign_num
     * @return
     */
    public int updatedigner(int check_sign_count,String check_waybill_consign_num);

    /**
     * 查询签收数据中时间最晚的一条
     * @return
     */
    public List<Check> selectsigner();

    /**
     * 查询签收序列的动态语句
     * @param check_waybill_consign_num
     * @param check_car_loading
     * @param shipper_com
     * @param check_date
     * @param waybill_reach_city
     * @return
     */
    public List<Check> selectallyuju3(String check_waybill_consign_num,String check_car_loading,String shipper_com,String check_date,String waybill_reach_city);
}
